﻿USE [RestaurantManagement]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Nguyễn Đức Thắng>
-- Create date: <15/03/2013>
-- Get_All_Restaurants
-- =============================================
CREATE procedure [dbo].[Update_Stock]
		@StockID as uniqueidentifier,
		@StockCode as nvarchar(20),
		@StockName as nvarchar(255),
		@Description as nvarchar(255),
		@RestaurantID as uniqueidentifier,
		@IsActive as bit
 as 
		UPDATE Production.[Stock] set 
			StockID= @StockID,
			StockCode= @StockCode,
			StockName= @StockName,
			Description= @Description,
			RestaurantID= @RestaurantID,
			IsActive= @IsActive
		 WHERE 	(@StockID=Production.[Stock].StockID)
GO
